Tasks

  1. Find the neighbourhood_group with the highest average housing price in 2024 (from January 1, 2024, to December 31, 2024).
  2. Find the proportion of “Private room” listings priced between 0-200 in the highest-priced neighbourhood_group of 2024.
  3. Identify the top three host names based on the number of their listings that received more than 50 reviews during Q4 of 2024 (September 1 - December 31).
  4. Display the geographical distribution of listings for the host with the highest number of listings identified in Task 3.